Jeff Reisman
Jeff Reisman
-
Re: Can't a System Admin recover a deleted sheet for someone?
@Matt Rasmussen if the user is active and their sheets/resources have not been deleted, a Smartsheet Sys Admin CAN transfer their owned sheets to someone else. The kicker is that they ALL have to tra…1 · -
Re: Moving completed rows onto an archive sheet automatically?
@SmartsheetRookie Sure. You can create an automation for this. Trigger: When a row is changed, when Completed changes to Checked Action: Move a row (select the sheet to move it to.)2 · -
Re: Countifs using greater than w/ date
Glad it's working for you. There are a few ways to look for a blank date field. One would be to change the > DATE(2022, 2, 15) to an = "" so that it equals empty quotes. =COUNTIFS({2021 …1 · -
Re: Oldest date in a column
You need to give the function a column range to work with, not just the column name. =MIN([Date Entered]:[Date Entered]) Make sure your "Date Entered" column is formatted as a date-type col…1 · -
Re: "A workflow has become invalid"
Something in your automation is causing a loop, and Smartsheet throws this workflow invalidation to prevent it from looping. Take a closer look at your triggers and conditions to be sure you're not s…6 ·
